﻿USE SchoolManager;
IF OBJECT_ID (N'dbo.Course', N'U') IS NOT NULL
DROP TABLE dbo.Course;
CREATE TABLE [dbo].[Course] (
    [CourseID]          INT              IDENTITY (1, 1) NOT NULL,
    [CourseName]        NVARCHAR (50)    NOT NULL,
    [CourseNumber]      INT              NOT NULL,
    [CourseDescription] NVARCHAR (500)   NULL,
    [Teacher]           UNIQUEIDENTIFIER NOT NULL,
    [CourseCost]        MONEY            NOT  NULL,
    [Department]        INT              NOT NULL
);
ALTER TABLE [dbo].[Course]
    ADD CONSTRAINT [PK_Course] PRIMARY KEY CLUSTERED ([CourseID] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF);


